SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528848 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528848 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (377537,605643,50549,122847,1015226,344763,617976,587681,331875,431477,1032343,724601,817598,773554,1012432,410808,582911,1033709,630407,965488,944120,393599,469564,652571,934966,48553,942034,85597,270759,418106,1012715,262601,822328,1034109,815269,806816,779038,761907,711974,981063,723342,986747,300873,255567,578456,927566,766395,943247,588529,525085,224235,248376,341429,654908,887738,1035393,539265,989837,205280,389721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528848 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528848 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]