SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568891 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568891 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338197,68664,387875,194601,385185,680061,570541,464805,142489,1042690,480090,148092,666858,503042,711826,42731,272255,730900,148606,777693,820453,870212,13580,828258,313785,550695,716410,310870,846303,86513,802967,819787,650605,962540,398598,230336,378620,578321,225583,960806,447106,621851,736244,507401,978485,45080,575633,629371,128810,211009,338974,200526,1048801,167955,606587,260106,78477,923864,73880,124513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]