SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461823 LIMIT 1 [ RunTime:0.000768s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461823 [ RunTime:0.004778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301506,82162,59940,626856,288033,868390,324274,223460,999445,22453,105024,465276,1032348,869372,184772,484225,266193,668850,525523,483862,594536,652404,466226,529739,631948,16749,243430,453224,538601,108202,884165,75353,130613,1000225,731453,426290,812137,186783,67269,390383,857710,36739,208713,71378,336670,231350,1014055,144102,1000538,303314,448121,895530,416025,20899,737601,987162,631942,18605,212127,487881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]