SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506251 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506251 [ RunTime:0.001475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342343,246322,862051,853879,1047709,163946,419385,971614,1023967,1046938,725639,347862,487257,922082,720733,772790,508536,487229,828479,364646,415551,522014,37382,227996,739965,132950,91629,201127,1004373,884932,555863,437869,362559,657963,197529,900408,466025,564607,573858,186466,317371,900303,8186,182543,864069,270807,511319,361459,857417,680851,546300,85035,830871,696621,792060,336559,851482,882614,809803,495601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]