SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410510 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410510 [ RunTime:0.002226s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205692,95577,254878,915521,1034130,586812,258185,831325,690939,854443,67536,1002156,135777,44560,774230,174710,236588,890418,85424,670351,89986,882376,327296,933045,382215,459937,1000462,541805,786761,284205,576098,40530,105346,643432,118034,116953,404561,581160,654697,146350,670983,445660,35602,330988,390666,703635,504668,860073,565137,660613,851330,367800,964017,1019674,88690,1034765,677868,174553,501719,269856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001780s ]