SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473437 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473437 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (787066,675703,684321,467171,310424,161790,960419,1003779,488629,752664,381694,92400,115478,649944,123523,566589,780130,392962,1006428,1037337,856227,877507,1036669,793561,754091,1041649,218539,776962,1046465,798410,918107,330773,287062,506516,44159,295052,918845,819050,346837,45236,995934,245573,230547,1047319,179539,690570,723314,925215,792946,515634,201279,933040,257599,318157,686621,202404,627264,577812,499715,883598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]