SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011650 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011650 [ RunTime:0.004864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399947,878075,465909,752852,10420,882769,324283,339076,738582,468384,254765,333113,282279,918559,433155,320788,550037,766584,660841,417409,182973,29270,39655,805532,167668,409770,156772,294349,984215,525325,94700,173778,144483,587479,184285,371067,93848,413227,795860,973254,359150,23263,484102,553070,207064,1031070,998747,693507,493556,598726,214600,840136,129175,401747,96488,952075,902888,749543,951337,31769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]