SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672991 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672991 [ RunTime:0.005593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046518,731894,2857,175923,110309,669463,1019349,447119,757989,951726,208865,368077,649442,177394,212473,489706,47897,515610,4169,898271,359027,994866,966711,800930,123563,139363,176771,361135,920884,993495,38985,317490,972461,940875,368298,249756,984251,599084,530045,161669,844079,161157,89000,116505,465527,695945,330569,399356,362559,776491,550471,440105,198802,439617,680751,579390,260958,44372,77039,326819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]