SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310226 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310226 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58208,821570,198083,88775,357031,406528,860685,240029,113502,492067,836834,373264,613215,26434,341574,218456,50464,164652,373821,287106,913118,901545,934734,669387,623289,489577,700884,156300,769844,891772,705365,488291,186336,90559,911564,152208,860293,910624,901614,584345,1035176,877179,207744,855918,896260,730491,956146,97704,1028267,62098,22891,287034,1003424,919652,1047142,853302,917852,852123,784214,536230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]