SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437401 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437401 [ RunTime:0.002283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706354,272805,517738,421923,709691,977163,564917,203315,129193,401849,607971,453935,832887,904447,67106,645405,450803,952792,684906,817731,425507,527897,231792,1048798,952419,426005,696129,282684,222546,283971,798706,611084,355899,792089,37322,198391,152326,512943,1000905,616043,771717,64119,167165,326358,724522,545572,14857,1046063,342904,29716,325270,852385,983209,245682,74222,1025540,1996,901990,738132,625657) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000717s ]