SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485323 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485323 [ RunTime:0.001947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395313,391200,7187,284189,281777,805870,312292,634029,533731,801110,147180,645201,1002804,797427,905747,559505,342322,616794,85512,921155,579692,1028038,76717,978870,173946,599618,185700,697975,564394,201386,53460,184253,704572,577654,52493,547030,603936,85192,729561,212550,764862,754865,700145,62612,151812,507793,369802,312702,273689,628213,817617,298448,400442,15684,218440,639183,344076,267086,618873,940181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]