SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345306 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345306 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171190,1036367,484757,981207,863208,320143,33676,150683,458620,900509,118858,365637,429305,1032903,70254,109477,182021,78544,173960,701428,1029845,303492,880441,1030055,309237,543557,271534,250186,626459,517305,501828,684370,718819,819107,469129,800137,16584,386332,486413,240106,869977,723006,648856,580513,350559,414590,577829,646080,846474,547316,62217,83673,646871,131904,269488,690407,893264,567988,85151,244189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]