SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004546 LIMIT 1 [ RunTime:0.006484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004546 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45673,186533,840002,495835,801842,734603,570673,882895,737196,673484,200728,801959,543948,200311,349720,106290,839936,259819,107131,42864,566070,707841,72410,701961,283745,261530,394299,593774,13712,600400,878469,1046280,582547,277555,837280,897842,14015,919981,523187,1014276,878909,291253,672565,591239,180731,175662,574619,125038,182227,996092,424385,696131,582911,814570,384606,698540,276997,36543,399194,311123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004546 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004546 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]