SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 867513 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 867513 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599981,574200,455748,1009540,1027472,783569,79279,536245,654236,448022,458462,285439,283698,726482,671349,894252,144068,799929,1001066,310726,42067,884115,818683,95621,221890,100874,264153,651653,1002277,712831,708768,3846,585332,675570,450870,584382,480278,1036801,261689,498843,224301,60131,1041686,983063,135494,374466,81421,447327,74170,934716,636915,938399,121577,302245,719387,422765,827896,255313,873973,287296) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 867513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 867513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]