SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 673195 LIMIT 1 [ RunTime:0.000572s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 673195 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761096,38026,657969,564439,694299,821215,802535,970350,850750,784565,625411,778568,452253,527101,1003356,111887,404903,746230,682496,800973,737811,727232,812581,169618,87347,88159,827579,27656,661977,487798,316505,468125,297620,840183,180718,73887,222480,361946,69982,1027408,18640,288458,43052,206237,275282,143825,448590,403457,294300,84513,318221,843019,942275,1026421,491733,989222,652717,683074,664750,948880) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 673195 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 673195 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001929s ]