SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503294 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503294 [ RunTime:0.001936s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82872,649600,378405,87232,206747,135806,1045338,344294,75989,268625,557645,451531,562328,847030,661770,484938,227616,114478,720923,514853,966865,880393,727689,397771,962693,153287,425163,1011627,391411,54950,930203,309639,78631,525151,972152,653286,707659,951134,871007,41362,207454,26438,104614,780971,916524,273397,847224,358938,416703,960054,806722,102749,533373,215283,171966,928297,649670,626275,354074,1021847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]