SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043045 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043045 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59636,1002300,567771,384210,584179,56653,750640,489041,570555,865233,88227,1040957,723304,185568,124556,528893,986301,415125,816875,794941,293106,199454,798559,149026,1018852,705901,177263,923299,766664,587158,79122,991707,723505,504758,621106,378056,883733,774213,411359,870824,93584,378557,223184,964112,431195,684200,800576,685841,374741,533879,179511,475634,336637,839079,42170,272034,760901,153256,851447,517714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]