SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455098 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455098 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894503,249238,695924,75036,573071,725096,480588,682050,628345,814997,776300,210602,401304,979265,805255,780756,523201,223885,854264,70947,121496,93751,920566,227209,789678,682487,1001940,411800,835810,446029,282919,905434,325039,879398,375798,374475,151157,931000,283336,187672,24352,343190,982415,708063,230972,500689,928564,677813,100837,792890,552018,916671,389551,1043807,627429,964540,50868,908073,768291,968861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455098 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455098 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]