SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 282099 LIMIT 1 [ RunTime:0.002204s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 282099 [ RunTime:0.004107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020038,710207,397113,453067,398355,1032160,470292,938872,440284,285135,546765,919300,992513,1028416,226565,315469,340655,391974,333232,487223,503691,522116,697204,171022,947923,542622,37003,723207,718145,422223,965592,373348,717974,542728,927381,957612,110877,973674,328848,742264,201378,462630,213023,958737,669285,790342,468235,251259,822348,239710,897490,752034,888416,68182,378253,191456,390113,437156,921098,482863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 282099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 282099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004430s ]