SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417306 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417306 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651261,320425,613926,824958,31333,608744,1019393,309833,463842,264134,1006153,247538,686518,187615,422084,38833,13788,115787,1019022,351955,819621,131487,844454,213899,1013343,1042480,410939,239723,736843,922497,463032,351657,268038,994701,218067,107709,142502,991181,18133,158612,287096,672997,194376,162335,207674,392811,434485,561526,608752,14437,877527,587161,128767,609392,995734,269178,293986,718876,1018408,30138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]