SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040825 LIMIT 1 [ RunTime:0.001690s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040825 [ RunTime:0.002674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403581,903655,333157,79677,81927,24358,68752,869580,955313,724286,968012,505261,454925,33001,698854,71595,360231,668816,243049,778451,245697,653802,376186,577848,553282,89546,79772,385296,272964,480602,586706,95060,90640,442921,662609,178030,815049,366853,1031139,525280,466440,1011602,393228,182603,64507,718099,647565,753298,879484,502742,56408,724308,526461,824907,215758,492531,3016,716528,965517,1021442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]