SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001892 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001892 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21962,491710,281493,556909,1024657,111275,703868,935117,969122,109971,398409,704074,658925,145056,401221,45933,225915,408472,551235,620338,985862,744087,345484,664207,880216,445328,996492,609562,609542,910840,604109,148335,673269,1036565,423382,125990,1037089,855754,777918,859791,146856,787237,941428,51837,410607,563638,992918,308419,748813,332581,724941,389818,1004080,415111,205333,203975,940157,544369,906485,383759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]