SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39801 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39801 [ RunTime:0.002354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721500,252842,338946,95025,696774,452286,205389,543057,264182,1034633,688107,784012,613020,477319,523547,544525,603044,769468,522438,495976,1032994,736080,3027,429966,37049,869787,380470,208143,785639,231705,219998,299654,579024,1034701,726523,1032290,24652,775324,167005,753427,616232,56767,844538,279215,960853,377073,721767,191389,536051,14612,500120,645681,440719,277598,632074,471069,747852,348210,720982,786965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]