SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411208 LIMIT 1 [ RunTime:0.001107s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411208 [ RunTime:0.002445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40902,405694,404625,501402,348245,215478,680339,355435,561112,190438,975016,522744,665961,909157,39259,308237,974958,961479,1033691,505190,967110,538382,914629,864578,833276,677075,104828,805659,671327,126774,755131,541124,135671,634903,564080,564070,884063,614750,986457,92706,78781,811250,566605,400050,113687,95130,835039,874171,130297,9005,150483,300763,351349,936467,270567,144082,137620,526081,49210,973745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001443s ]