SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035546 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035546 [ RunTime:0.007411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252119,194735,137475,405593,410850,715918,806638,207178,825964,152505,357314,750955,999241,349876,712057,604141,805501,833243,644276,990170,201188,891275,503891,9119,382907,453762,378555,846228,475719,388724,692288,1027810,675010,593960,295689,493615,55104,431032,513201,313341,692762,878735,888678,136200,528044,516745,340387,363321,156000,143210,212411,650591,415830,274274,252824,123495,316457,914684,422444,355902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.010351s ]