SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541647 LIMIT 1 [ RunTime:0.000613s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541647 [ RunTime:0.002261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196419,477804,486116,261897,532054,325876,381833,393635,212302,448363,271827,657867,497816,509908,587660,858627,231339,816293,418875,170631,125796,513378,927455,843281,159629,404183,698509,198719,687018,40389,590611,658400,750049,165394,687500,407212,70538,250611,96822,682786,56966,85757,700407,960532,310267,1037199,58655,508591,834845,802108,52614,876861,753368,86403,539378,125493,195953,201317,511148,644900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541647 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541647 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]