SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001741s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391654 LIMIT 1 [ RunTime:0.000749s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391654 [ RunTime:0.005426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527212,994791,149786,53819,187354,370129,29389,690070,119580,717648,359773,296458,446507,35158,1036328,846938,192719,498487,466536,27020,605071,871435,594185,131540,670994,1042887,7604,800195,713877,63465,491689,38677,427919,59507,359497,997885,247624,645281,553103,297207,850094,858471,877420,320395,995329,551069,750438,97335,71615,426389,548850,80026,1028178,892855,303281,227422,700011,369233,991133,728113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002523s ]