SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438380 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438380 [ RunTime:0.002904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903566,78381,186189,431990,871581,515813,108782,806803,616583,232002,835732,337685,341937,754295,476130,506052,979328,745591,396702,490351,865650,223791,395714,602149,877942,931485,948628,112767,908592,95739,948464,780912,189607,529465,642369,128884,387552,827806,560292,658033,589400,103777,375932,494151,27904,133773,621512,233731,26159,540915,307147,195890,486524,904298,82589,905656,542948,949893,245096,313359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000697s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001775s ]