SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527028 LIMIT 1 [ RunTime:0.001309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527028 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393016,392416,471981,770192,459413,1017460,917401,215642,818366,816763,238761,641978,689056,821059,836366,181761,953503,436097,1145,766281,609907,602144,881865,822784,131386,604143,979130,638654,764050,355068,216498,514256,841673,846878,426193,694228,270871,773936,496675,584678,26943,498500,1037327,107063,1024217,269174,908844,230568,93497,66336,887529,241158,366256,813390,7288,171748,540844,843680,504972,451688) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]