SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105455 LIMIT 1 [ RunTime:0.001135s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105455 [ RunTime:0.004369s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697918,714681,973050,285962,212830,98393,101238,659282,18958,1008898,471088,220051,382644,561063,108254,1035272,323507,623869,935891,450398,378574,89716,299830,122009,416933,974565,227846,196723,493994,376396,220667,355975,915590,56684,235600,849559,941157,914384,444750,545811,36860,476372,908606,40963,27942,722266,890850,103279,884785,882776,176189,460812,84083,680109,706001,426570,1009918,536778,713968,714981) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]