SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801628 LIMIT 1 [ RunTime:0.000799s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801628 [ RunTime:0.002144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1027527,344057,596256,986663,255094,325793,247800,669394,436016,897114,681163,176293,265620,206348,836998,1002189,3296,52002,244845,579931,1019915,549775,754802,371423,1040251,313582,9419,217258,256650,218788,807151,900404,915286,855049,631957,310043,674709,344550,817142,309358,32891,1041164,159508,681989,822678,723767,13882,736163,1037235,444980,308005,416753,32044,540292,612151,860270,105512,613633,493875,266608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002321s ]