SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110417 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110417 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946710,802991,827825,478052,1044823,551128,468048,641146,329476,110004,866331,981913,396888,275102,134528,452760,993317,1048527,46622,248727,8894,960002,108166,54477,385147,284110,1045505,276727,661600,385928,644350,426541,17157,87212,590156,532581,465673,249490,5443,9448,674768,372444,961660,3099,222103,538504,324967,223700,991494,71619,588773,598071,964267,772433,716621,752420,381436,1029405,45298,783225) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]