SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421603 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421603 [ RunTime:0.001655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558844,1003228,891444,881971,297422,39366,516541,227772,270406,287189,555959,385873,224412,897626,720260,922804,71319,290334,514583,1039883,943125,877566,172933,744455,423340,267456,897570,1021188,274713,704261,344331,440372,100613,30060,522581,739309,676289,804707,458970,725615,737612,260733,460210,912011,158974,368812,157683,60314,4723,393246,808619,806204,416467,392332,630226,999615,879767,268941,592621,111091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]