SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35443 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35443 [ RunTime:0.001099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251483,50301,453461,98569,545805,381941,450230,871247,84265,622508,224817,40322,182670,823746,646517,834122,978417,361478,601599,753049,57730,662366,406389,35326,290380,343383,993684,675822,351675,435406,382914,160905,560472,800502,875482,563814,906007,134470,373653,867687,107898,123444,1031855,344846,735789,412395,141557,436650,75346,606982,127020,173784,732284,289388,92541,1005595,75706,813999,952770,179080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002431s ]