SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39380 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39380 [ RunTime:0.002167s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (936725,99035,94870,230722,324547,1029955,824168,86966,369660,274506,862899,1013116,922581,607585,393623,585012,207506,437148,47657,75889,1011569,680046,775530,591577,423652,117429,802024,262874,673827,827194,248874,855853,687590,519967,322431,381439,1006724,261902,140676,343237,523122,230873,900771,166551,212351,445792,550910,67537,261982,90600,27337,883097,629979,459997,1048076,788920,648268,575899,409164,247728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]