SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030601 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030601 [ RunTime:0.002522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80381,602380,160583,442875,702018,160490,251852,508906,539388,874939,735314,680705,663481,94109,986552,412222,573131,439979,885674,164661,616949,174471,696861,599494,1005460,202699,802852,777319,789383,169952,120927,734702,294957,47722,700462,681685,618073,311337,492405,766088,178607,345439,72104,203701,740976,948300,199042,320190,735998,247941,559136,655699,555680,153616,264924,963200,541867,925555,323910,992051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]