SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413640 LIMIT 1 [ RunTime:0.002693s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413640 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441296,706489,22847,447516,511716,7712,568254,869903,604900,709693,165965,431436,394051,927225,732564,655693,672540,179499,199188,379371,521904,864067,189725,904103,453727,194872,107346,176747,246905,396219,239970,827708,707940,995618,108068,932207,1023573,310808,918019,605470,295926,293038,796558,424149,60289,811508,1046043,535170,310172,630796,481255,835301,774668,591057,115029,56310,732538,277130,772056,577115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]