SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410621 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410621 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207814,252748,299662,862819,193128,530653,575146,730564,115250,870525,271607,488915,884360,450768,56087,23576,472463,93816,224750,103779,226055,484004,25919,862639,447681,816257,547824,829189,473331,767267,632706,531531,460998,178030,542444,871131,784081,913128,1040568,624823,436171,576004,711429,355789,666329,246781,602800,778803,864590,978044,131518,142339,1008988,794622,194831,328358,901595,146784,307730,812658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]