SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001675s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205800 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205800 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667429,195971,981000,923430,838413,395586,250707,573739,699190,197215,253740,779509,223154,791577,29064,1006842,631820,494866,656007,283982,115362,453332,21834,1005626,179492,388809,748585,800984,367838,222345,382142,293137,266345,984973,1024010,681113,645693,402311,742360,766899,532412,47788,678309,72184,889374,886345,259498,364866,669865,824295,290831,721291,301022,9568,567323,967067,134097,118742,871699,323432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001113s ]