SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107570 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107570 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634882,238866,410732,212810,1032731,853887,801878,74490,288244,459983,412769,283816,644895,171683,142946,119057,914653,608163,396437,678807,987149,249034,167866,374547,9819,680664,299777,522882,209258,355852,507014,808710,801703,422762,922793,136773,88568,550652,634150,279438,567014,184393,256684,826764,87903,118805,933628,72837,781060,1041431,507780,211131,999089,976489,126568,802858,933348,198608,781087,1003381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]