SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380088 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380088 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442651,234259,144482,98181,610057,781093,701071,542323,20061,97877,975651,300693,9703,835823,769420,255119,524762,434280,291685,913805,351568,454317,690320,771780,277292,665472,125255,602649,996179,180437,254408,98100,309701,305103,740258,588363,87856,420540,82803,184464,87650,941715,761202,82553,812719,902105,517160,239702,63669,236541,642911,485889,214632,757237,5420,407644,697685,944512,885868,502901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]