SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023332 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023332 [ RunTime:0.003399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915773,748610,452116,7791,394948,490709,315375,227738,286357,691556,198726,197330,159088,401823,106489,188977,140384,593030,681488,567813,1011371,4919,450933,591504,917326,1041396,874477,312717,656835,394702,11526,686841,271546,951480,169746,491889,871102,585487,118180,1032973,927306,230490,17107,126269,468926,600357,769161,370537,1009475,842155,835655,394989,507047,647918,671459,57509,594587,985772,52825,961456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023332 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023332 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]