SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466753 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466753 [ RunTime:0.001495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918959,592403,272416,248189,731220,192534,468331,170968,917570,645513,222671,832720,971765,225218,86603,266128,600737,1014484,784903,841618,935442,702713,556812,5731,338964,915696,867766,949738,248698,587441,536349,150129,151372,267699,527744,794958,890658,798059,564938,993576,957899,214555,316020,210389,510712,834229,393831,242509,605550,569392,734463,882690,405513,993897,976372,930797,246065,168091,1028842,858797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]