SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568713 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568713 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661628,369118,266366,937423,253732,886423,634738,247189,772213,597603,27863,435374,988978,815000,928177,646464,699291,229299,284750,205792,429740,127449,70274,548848,955565,316603,878293,419133,51665,692866,393613,11835,824866,711431,268442,522297,881701,607625,45330,491334,1001709,855837,92494,888544,151916,847366,272311,211951,905108,826552,196517,627514,309123,420300,310883,229164,378891,624718,877666,863677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]