SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001684s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401467 LIMIT 1 [ RunTime:0.000668s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401467 [ RunTime:0.002957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165599,778368,602452,978387,795227,180544,291243,384156,352677,833983,423020,525788,474725,4358,596531,921868,330719,473593,359541,443805,994314,1010935,260688,516837,885573,283180,691589,316510,385106,471095,547666,157408,907429,405280,907385,1020389,588107,136126,575600,67961,45411,950665,912991,705915,208849,290959,296262,603722,633345,74594,487101,76239,464819,452100,261675,739267,330536,566347,923939,435952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401467 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401467 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]