SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001926s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012086 LIMIT 1 [ RunTime:0.001839s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012086 [ RunTime:0.007670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625502,68784,1000537,621322,89592,187494,767941,872061,118393,497702,35464,92631,159423,669169,591234,501679,195394,907789,895339,199350,4264,995485,745787,486407,249051,697031,713570,671249,150427,397287,816387,30782,468472,904412,932265,782057,678143,987231,182815,814459,938371,1031136,708953,809919,722151,608086,346940,481316,591643,205743,275437,844633,349189,965644,93165,923679,817209,251054,225817,53806) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]