SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405681 LIMIT 1 [ RunTime:0.000782s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405681 [ RunTime:0.003022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273745,807045,194490,203185,413619,414092,856921,183142,245449,372765,296312,549183,588545,298472,260279,1023029,161188,874768,454786,539976,134341,265756,774946,308158,298896,564748,405316,859380,117154,598199,401047,517563,64489,192250,437230,62773,264193,81589,436219,300867,27299,791758,599546,466654,1022765,861477,662768,911343,477780,582172,694368,883358,561809,275198,740890,243356,591339,560418,588236,933339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]