SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 57583 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 57583 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292727,822840,778779,628965,537869,808292,245516,38345,91261,940632,633456,675634,615682,473933,1011249,875408,1026087,382709,301754,297965,976009,544502,539948,381191,377686,855619,226827,1020172,181293,11833,162492,735749,462571,302491,893732,583095,278501,246281,122431,292333,655853,504255,424342,254989,135217,145199,868804,744712,707910,375516,735779,800537,171521,782783,613202,646565,97870,915650,190365,323515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 57583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 57583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]