SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554807 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554807 [ RunTime:0.003126s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412589,886161,485805,339555,710963,1016948,205280,237866,618860,821679,28647,910572,383936,900631,43467,716384,935528,145407,809310,822543,711365,324554,472111,378628,145614,795634,929450,561456,533871,794411,9382,999008,944386,788347,133926,894990,207736,622048,975525,601964,697988,861007,329205,537283,135552,207916,641547,275081,479495,741594,237870,211671,615084,897056,504319,278287,901954,798519,305896,631931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]