SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045633 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045633 [ RunTime:0.003746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (544720,283690,945380,457320,366652,139994,4531,1026921,349313,850954,681518,562277,557900,946897,243291,633069,288793,695725,908111,943389,349378,4122,220107,466164,799643,309018,647410,713218,775606,321655,578050,635834,139745,11833,706345,350426,78222,709124,751136,141632,216699,719347,823711,580918,564718,360723,366003,314160,828481,655597,123472,927394,352432,553547,144870,112209,385123,605439,552046,971884) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]