SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 295673 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 295673 [ RunTime:0.002657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (909658,359774,841746,220073,1004075,386521,939296,579986,76636,851376,335368,831739,294941,1030057,877356,826234,58983,46021,112714,776169,307220,302263,34346,317539,95158,476972,942228,412948,871136,273252,784471,66859,969929,683125,424914,380051,126293,295978,310275,83094,440559,522814,763873,889679,295936,434721,237992,534541,331029,703023,987437,563402,468871,445933,90337,502440,16101,875537,766817,191872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 295673 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 295673 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]