SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484243 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484243 [ RunTime:0.001426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817116,948472,963620,561679,989795,466344,435840,159820,654199,366558,803620,683565,543316,24810,829815,838933,401716,889047,544732,692319,125355,723193,520758,1034639,1029452,237972,597952,152702,345634,286855,158292,974002,913430,982840,154075,355467,429312,130520,811902,563720,728928,946903,722623,989808,187845,598596,593091,754018,1009020,353291,300727,848745,523049,639895,378851,264954,413130,244755,162371,955797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]