SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483300 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483300 [ RunTime:0.002275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011005,963577,44084,993793,280413,563057,67173,501552,214810,292311,343396,134997,854362,392785,845372,547939,853724,127665,391847,226790,858292,538024,65747,250648,325331,964921,713067,710921,674483,841738,909025,180514,20304,458483,944895,799445,493536,357033,1004765,918327,568970,28375,536415,469834,313159,546883,211941,400203,268440,670945,215078,239919,989028,607344,514769,878778,374280,957289,555852,885787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002287s ]