SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037850 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037850 [ RunTime:0.001978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (653169,527856,474946,916528,52476,282212,483770,458070,193417,168919,142015,889454,286584,428309,726155,245167,961002,308598,744063,444349,895006,815917,667427,986404,485452,922568,670438,642911,787692,405707,215487,822945,818353,447267,1004681,518183,168912,587632,148269,179161,616291,86856,950130,400425,779270,581995,318718,613446,66167,968711,556491,78075,809398,983295,258380,518980,974645,472419,356531,1012513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037850 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037850 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000769s ]