SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262270 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262270 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417132,327687,669332,113779,37823,407930,1025318,15489,881193,625068,596432,191835,496871,785519,522379,760202,697509,935039,29775,806626,928087,702968,125154,1045159,862770,866165,27831,508643,957316,623863,391685,84304,570603,445499,445218,162551,734687,229614,93023,96033,893329,284114,924207,490237,793048,101571,615532,445153,178746,825664,561262,268828,461022,152214,914122,875657,879454,348248,919394,446839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002997s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]