SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001632s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538431 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538431 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402612,955367,1010929,1021626,1006797,143250,657070,956559,500919,995002,59644,288555,786806,177952,542630,87851,1022743,887950,250042,411189,335770,1023012,1014305,414182,37726,853208,1045010,99874,712984,919823,175405,350187,1026771,1014127,1022424,391014,347668,555743,727205,573337,221019,172180,789922,514311,844242,355427,475820,27735,568307,21616,659006,414221,468329,74195,840673,322436,309035,940321,18263,396131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]