SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103031 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103031 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627395,167665,475638,1044205,341216,83102,475591,976630,1006047,412062,800625,338168,276586,727585,90095,1023478,412521,570653,243783,903697,1019566,100984,866773,262987,171298,51886,57498,277440,317413,976410,410053,70644,923031,707244,660152,1047025,590088,922988,279040,4145,214852,198243,473632,712906,691983,36879,116288,615991,389871,369380,625691,987566,536637,232440,384468,880082,75670,549330,333552,111663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103031 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103031 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]