SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033223 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033223 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374432,696170,668452,17171,889190,995303,689837,54930,919332,1019203,544350,604167,118560,713708,986013,580363,412951,443232,861581,119036,1042208,19825,288723,670206,740705,533837,787043,950819,162013,115316,871826,372003,1009508,40444,182860,661347,157988,179002,400139,446375,493420,335894,720002,377706,406650,240999,604476,808519,314597,450407,56935,834000,970182,333694,164604,775717,256928,733540,81842,122390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000897s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002788s ]