SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012276 LIMIT 1 [ RunTime:0.003222s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012276 [ RunTime:0.003272s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643700,457467,696628,1012175,949848,881562,997673,671201,652675,115932,676739,184138,585827,489795,186253,318987,634435,333950,94977,366330,318967,437459,188549,690512,96303,597480,911521,899941,1025319,615880,1016484,648079,83826,159399,362336,311329,822136,573084,734043,160041,540895,268407,721795,775835,67290,93416,304799,25325,667039,187566,733472,34891,310291,716961,7438,922397,127477,13756,242507,258431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001004s ]