SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684518 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684518 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847586,709797,208783,353867,85318,583094,149005,368843,511904,227964,792686,399260,911448,655074,525310,763229,82827,627681,887735,108596,263065,798107,104807,649533,162072,164798,553508,177725,809074,917276,994969,243485,569516,324791,410518,177302,176085,855193,270413,645481,539406,368900,708392,423818,297934,248322,554312,221085,978678,524414,644010,914584,1040545,503352,224795,901438,1010357,85391,336753,21019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004846s ]