SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040200 LIMIT 1 [ RunTime:0.000744s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040200 [ RunTime:0.003396s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374806,747606,438510,302717,853710,765456,855041,614436,408401,249838,548857,472342,415224,390712,906052,577411,955601,397897,940462,58681,494973,474854,680559,124111,801418,72296,403390,513786,885205,463875,682014,889186,123862,386201,79534,828137,40577,988908,1035932,966182,931843,643197,700007,341672,685685,838802,563691,251398,730898,507386,773324,958686,945589,191549,891072,231850,94679,781871,656029,364326) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]