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` = 502093 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502093 [ RunTime:0.002300s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503132,484602,934991,1009612,781389,442786,209164,882349,172685,657580,831666,739039,244194,173101,342294,825672,65830,734678,947026,263439,328421,924365,428584,213660,730635,290772,263686,686588,463517,1036016,334053,1009695,388436,302366,66792,109,673139,360654,907817,454395,478745,355990,156787,193446,139151,105601,859882,87626,333468,500736,932757,614126,437190,151004,304853,476351,427788,229299,261859,762716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]