SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001765s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018050 LIMIT 1 [ RunTime:0.000597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018050 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174320,692630,607658,1009141,268480,482291,806030,434672,521002,11685,600528,843088,48831,676727,199860,122662,732484,877005,445623,617612,145346,658572,621046,1037902,723379,248540,300803,1017786,273517,744294,95707,35895,719427,326052,923941,294546,511605,948404,649846,1002395,772376,498463,474673,34908,93149,687423,118106,609436,1032186,433326,77869,555057,886739,703425,838277,151065,249345,135436,808736,50928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]