SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035011 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035011 [ RunTime:0.009311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125815,909049,484668,790141,798791,903931,209294,331497,639792,10071,901590,765537,1025637,345781,174034,380843,399077,847353,909415,984110,344998,211088,968724,645048,252934,916174,365805,239724,235333,754261,162628,287221,591321,596813,820201,733078,853116,249339,153281,1047065,135916,794349,971514,172787,934835,501723,852048,554495,680414,908300,51638,531888,874766,375196,677835,672506,597607,612009,286838,154135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000673s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001360s ]