SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002698s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 408910 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 408910 [ RunTime:0.006583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138312,427345,705054,890906,577355,54871,588766,493021,614786,601238,476731,760090,613980,581255,57711,73820,813253,815875,624860,701251,79557,518346,468790,915109,49629,946406,727280,160114,461929,70502,184790,477004,961150,129895,39998,209413,258038,7200,118791,482088,737638,895015,124068,655352,181149,31609,149880,860569,941307,412528,118922,725602,859611,1048869,41814,295132,171017,264999,932705,763232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 408910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 408910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000796s ]