SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419602 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419602 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454402,300525,647128,1025268,740671,511289,408575,814098,467317,800620,809609,473982,805109,942683,460168,928454,453783,370461,19112,487419,449119,229225,952902,798787,533819,67816,387020,161523,509843,235289,313321,592708,940192,878156,638101,206823,819605,611707,231809,227727,820948,258534,981894,533268,945742,694042,27999,383923,98337,384711,687734,580703,116667,903510,985285,744928,180795,552120,84594,967910) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]